USE [DSRSystem_Temp]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spGetIndicatorTemplates]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[spGetIndicatorTemplates]
GO

CREATE PROCEDURE [dbo].[spGetIndicatorTemplates]
AS
BEGIN
	SELECT [IndicatorId]
		  ,[IndicatorName]
		  ,[IndicatorNumber]
		  ,[IndicatorSortKey]
		  ,[ThemeId]
		  ,[ThemeName]
		  ,[ThemeSortKey]
		  ,[IndicatorCategory]
		  ,[IndicatorCategorySortKey]
	FROM [dbo].[IndicatorTemplates]
END
GO


